
package DBLayer;
import ModelLayer.*;

import java.sql.SQLException;
import java.util.ArrayList;

public interface IFDBCustomer {
    // get all customer
    public ArrayList<Customer> getAllCustomers(boolean retriveAssociation);
    //get one customer having the cprno
    public Customer findCustomer(String cprno, boolean retriveAssociation) throws SQLException;
    //find one Customer having the fname
    public Customer searchCustomerFname( String fname, boolean retriveAssociation)throws SQLException;
    //find one Customer having the lname
    public Customer searchCustomerLname( String lname, boolean retriveAssociation)throws SQLException;
    //find one Customer having the cprno
    public Customer searchCustomerCprno (String cprno, boolean retriveAssociation)throws SQLException;
    //find one Customer having the phoneno
    public Customer searchCustomerPhoneno (String phoneno, boolean retriveAssociation)throws SQLException;
    //find one Customer having the clubIC
    public Customer searchCustomerClubID (int clubID, boolean retriveAssociation)throws SQLException;
    //insert a new Customer
    public void insertCustomer(Customer customer) throws SQLException;
    //update information about an Customer
    public void updateCustomer(Customer customer) throws SQLException;
    //delete customer
    public void deleteCustomer(Customer customer) throws SQLException;
}